<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Creating a transformation shortcut metric</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
ol.whs3 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nCalculating data on a report: Metrics\nPercent-to-total, rank, and transformation metrics: Shortcut metrics\nCreating a transformation shortcut metric");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Creating a transformation shortcut metric</h1>
<p class=SeeAlso>
<a href="Creating_a_shortcut_metric.htm">Shortcut metrics</a> 
 are a quick way to add new metrics based on the existing metrics of a 
 report. </p>
<p class=SeeAlso>Transformation shortcut metrics apply offset values, such 
 as &quot;four months ago,&quot; to the selected attribute. The offset 
 value is called a transformation. Use transformation shortcut metrics 
 to compare current values for a given metric against corresponding values 
 for that metric across a time period. </p>
<p class=SeeAlso>For example, if you add a Last Year transformation to 
 a revenue metric, the new shortcut metric calculates last year's revenue. 
 </p>
<p class=SeeAlso><span style="font-weight: bold;"><B>Note</B></span>: Transformations 
 are schema objects and therefore only a project designer with schema object 
 privileges can create them. For more information on transformations, see 
 the <span style="font-style: italic;"><I>MicroStrategy Project Design Guide.</I></span></p>
<p class=SeeAlso style="font-weight: bold;"><span style="font-weight: bold;"><B>Prerequisites</B></span></p>
<ul type="disc" class="whs1">
	
<li class=p><p>You must have MicroStrategy OLAP Services to create 
 shortcut metrics. To evaluate OLAP Services, contact your MicroStrategy 
 Account Executive or e-mail MicroStrategy directly at <span class=Code>info@microstrategy.com</span>.</p></li>
	
<li class=p><p>Transformation shortcut metrics must be calculated in 
 SQL and are therefore only available to users that have the privilege 
 to manipulate objects within the Report Objects tab.</p></li>
	
<li class=p><p>Shortcut metrics are available only if DHTML is enabled. 
 See 
<a href="DHTML-only_features_in_Web.htm">Enabling DHTML in Web</a>.</p></li>
</ul>
<h2>To create a transformation shortcut metric</h2>
<ol type="1" class="whs2">
	
<li class=p-Steps><p class=Steps style="margin-left: 0px;">Click the 
 name of a report to execute it. The report must be in either Grid view 
 or Grid and Graph view.</p></li>
</ol>
<ol start="2" type="1" class="whs2">
	
<li class=p><p>Right-click the column(s) or row(s) to use to create 
 a transformation metric.</p></li>
	
<li class=p><p>Select <span style="font-weight: bold;"><B>Insert Metric 
 </B></span>and point to <span style="font-weight: bold;"><B>Transformation</B></span>. 
 A menu opens with the following options. Select the transformation interval 
 in which the selected column or row is to be displayed:</p></li>
</ol>
<ol type="disc" class="whs3">
	<ul type="disc" class="whs1">
		
<li class=p-SeeAlso><p class=SeeAlso><span style="font-weight: bold;"><B>Normal</B></span><span>:</span> 
 Displays unit figures for both the current values and corresponding values 
 for the interval selected. </p></li>
		
<li class=p-SeeAlso><p class=SeeAlso><span style="font-weight: bold;"><B>Variance</B></span>: 
 Calculates the difference between current values and corresponding values 
 for the interval selected, for example, Revenue - (Last Year's (Revenue)). 
 </p></li>
		
<li class=p-SeeAlso><p class=SeeAlso><span style="font-weight: bold;"><B>Variance 
 Percentage</B></span>: Calculates the difference between current values and 
 corresponding values for the interval selected, expressed as a percentage. 
 For example, Revenue - (Last Year's (Revenue))/(Last Year's (Revenue)). 
 </p></li>
	</ul>
</ol>
<p class=SeeAlso style="margin-left: 0px;">A new column of metric values 
 is displayed on the report.</p>
<p class=SeeAlso style="font-weight: bold;"><span style="font-weight: bold;"><B>Related 
 topics</B></span></p>
<ul type="disc" class="whs1">
	
<li class=p><p>
<a HREF="Steps_to_create_a_shortcut_metric.htm">Creating 
 a percent-to-total shortcut metric</a></p></li>
	
<li class=p><p>
<a href="Creating_rank_shortcut_metrics.htm">Creating 
 rank shortcut metrics</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
